﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace WPFContribDataAccess
{
    public class SQLParms
    {
        public enum DataAccessType { OleDB = 0, SQLite = 1, SQLServer = 2, Oracle = 3, mySQL = 4, postgreSQL = 5, mongoDB = 6, ravenDB = 7 }

        private DataAccessType _data_access_type;
        public DataAccessType SQLDataAccessType
        {
            get { return _data_access_type; }
            set { _data_access_type = value; }
        }

        private string _sql_con_str;
        public string SQLConnectionString
        {
            get { return _sql_con_str; }
            set { _sql_con_str = value; }
        }

        private object _sql_con;
        public object SQLConn
        {
            get { return _sql_con; }
            set { _sql_con = value; }
        }

        private object sql_cmd;
        public object SQLCmd
        {
            get { return sql_cmd; }
            set { sql_cmd = value; }
        }

        private object _DB;
        public object DB
        {
            get { return _DB; }
            set { _DB = value; }
        }

        private DataSet _DS = new DataSet();
        public DataSet DS
        {
            get { return _DS; }
            set { _DS = value; }
        }

        private DataTable _DT = new DataTable();
        public DataTable DT
        {
            get { return _DT; }
            set { _DT = value; }
        }

        private List<string> _columnNames = new List<string>();
        public List<string> ColumnNames 
        {
            get { return _columnNames; }
            set { _columnNames = value; }
        }
    }
}
